So this one is not a musical but hey not every beautiful story has people randomly bursting out into song... sad huh, Any way this is an awesome movie so enjoy, and Wikipedia says...
The Illusionist is a 2006 period drama written and directed by Neil Burger and starring Edward Norton, Jessica Biel, and Paul Giamatti. Based loosely on Steven Millhauser's story "Eisenheim the Illusionist", The Illusionist tells the story of Eisenheim (Norton), a magician in turn-of-the-20th-century Vienna.

The film premiered at the 2006 Sundance Film Festival, opened the 2006 Seattle International Film Festival, and was distributed in limited release to theaters on August 18, 2006, eventually expanding nationwide on September 1.The film begins in medias res as Chief Inspector Walter Uhl (Giamatti) recounts the story of Eisenheim for Crown Prince Leopold, following Uhl's visit to the theatre to arrest Eisenheim during what appears to be necromancy passed off as a magic show.

Eisenheim was born the son of a cabinetmaker in Austria-Hungary. One day when he was a teenager, Eisenheim (played as a young man by Aaron Johnson) meets a traveling magician along a road. The magician performs several tricks for him and then, according to various accounts, both the magician and the tree he was sitting under vanish. Eisenheim becomes obsessed with magic tricks after this.

He also falls in love with Sophie, the Duchess von Teschen (Biel, played as a young lady by Eleanor Tomlinson), a noblewoman well above his social class; her parents have hired Eisenheim's father as a cabinetmaker. Young Eisenheim makes Young Sophie a unique marquetry puzzle locket, which if twisted correctly reveals a small, hidden photograph of Eisenheim. Although the two are forbidden to see each other, they meet in a secret hideout chamber in the woods, where Eisenheim tells of his plans to go to China to learn more magic and Sophie promises to go with him. On the day that they are going to leave, however, the police come looking for Sophie. The two hide in the secret room and Sophie begs Eisenheim to make them both disappear. He is unable to fulfill this request and the two are separated. This event has major significance on their future lives and one that Eisenheim learns a great lesson from.

Eisenheim leaves his village to travel the world; he perfects his magic and returns 15 years later as a master illusionist. He meets Sophie at one of his performances, when she is volunteered by the ruthless Crown Prince Leopold as a reluctant participant in a trick. He soon learns that Sophie is expected to marry the Crown Prince, who purportedly has a history of abuse towards women. Eisenheim and Sophie, having recognized each other, meet privately, whereupon it is revealed that Sophie still has the locket he made for her years ago. After humiliating the Crown Prince during a private show, Eisenheim finds his hit performance shut out of Vienna. When Sophie comes to offer him help, the two consummate their relationship and realize that they are still in love. They plan to flee the Empire together; but first, Sophie points out, something must be done to stop Leopold, who, she reveals, is planning a coup d'etat to usurp the Crown of Austria from his aging father, the Emperor Franz Joseph I, while using his engagement to her to win the Hungarian half of the Empire as well. She also knows that the Crown Prince will view her as disposable if she leaves him for another man, and that he will have both her and Eisenheim followed and killed in order to protect his ego. alot apparently.